Configuring the XFM Schema
Prepare for Register Features
A short cut should be created to ensure the correct settings are enabled when running register features and when exporting workspaces from GSA
To create a short cut to GSA :
- Copy the default GSA short cut to your desktop
- Right-click on the short and select rename.
- Enter a new name for the short cut.
- Right-click on the short cut and select properties. The Properties dialog opens. .
- Add the command line start options –expand=true and –register_fullname, e.g., "C:\Program Files\Bentley\UtilitiesDesigner\Map\bin\GeospatialAdmin.exe" -expand=false -register_fullname.
- Click the Apply button.
- Click the OK button to close the Properties dialog.
To create a base XFM file for Oracle Spatial :
- Navigate into the DataModel folder, e.g. C:\Program Files (x86)\Bentley\UtilitiesDesigner\UtilitiesDesigner\DataModel\BentleyUD.
- Copy BUD_DGN_Base.xml to BUD_OS2T_Base.xml.
- Start GSA and open BUD_OS2T_Base.xml
- Change schema parameters to your Workspace preference – E.g. Project Name: BentleyUD_OS – E.g. Description: Bentley Utilities Oracle Spatial schema.
- Right-click on Graphical Sources>OracleSpatial Connection. A popup menu appears.
- Select "Add>New…" in the popup menu.
- Enter the connection parameters for the Oracle database. Typically, it should match the service name, user, and password specified in the Settings tab of the BUDOracleSpatialTools workbook.
- Click the Test button. A message should display declaring "Connection Successful".
- Click OK in the message box.
- Click OK in the Build Connection dialog.
- Save the base XFM schema file and exit GSA.
To create the XFM schema file for feature registration :
Macros that generate the XFM schema file must be run in the order illustrated by the diagram below. The first macro takes BUD_OS2T_Base.xml as input and produces BUD_E_OS2T.XML. Each successive macro takes as input the file produced by the previous macro and so on. If you are creating a schema with only one commodity or a subset of the commodities, you will need to adjust the input file names in the VBA macros.
- Navigate to the Electric folder "DataModel\Electric\".
- Open _BentleyElectric_DL.xls.
- Execute the macro Export_BentleyUD_DGN_Base_E.
- Navigate to the Gas folder "DataModel\Gas\".
- Open _BentleyGas_DL.xls.
- Execute the macro Export_BentleyUD_DGN_E_G.
- Navigate to the Water folder "DataModel\Water\".
- Open _BentleyWater_DL.xls.
- Execute the macro Export_BentleyUD_DGN_EG_W.
- Navigate to the Wastewater folder "DataModel\Wastewater\".
- Open _BentleyWastewater_DL.xls.
- Execute the macro Export_BentleyUD_DGN_EGW_WW.
Register Features
To Register Features with GSA :
- Navigate to the multi-utility folder, e.g. DataModel\BentleyUD\.
- Copy BUD_OS2T.XML to BUD_OS2T_Registered.xml. This step saves the original XFM schema file just in case you need to restart the Register Features process.
- Start GSA using the –expand=true and –register_fullname options.
- Open BUD_OS2T_Registered.xml .
- Right-click on Oracle Spatial Connection>Named Connection. A popup menu appears.
- Select the Register Features menu entry in the popup menu.
- Select all the options except "Topology Features" in the Database Login screen and enter the password for the user login.
- Click the OK button in the Database Login dialog. The first Register Features Wizard screen appears after about a minute.
- Click the Select All button in the "Welcome to the Register Features Wizard" screen. Do not click the Next button just yet!
- Unselect each of the following features in the "Welcome to the Register Features Wizard" screen.
- Click the Next button in the "Welcome to the Register Features Wizard" screen.
- Click the Next button in the "Feature Names" screen. The Next screen appears in about 2 minutes. See section 6.1 in Known issues before accepting the defaults in this screen.
- Click the Next button in the "Specify Composite Surface Features" screen.
- Click the Next button in the "Point Geometry Rotation and Scale" screen unless you prefer Rotation in degrees or if you changed the names for Rotation, X Scale, and Y Scale parameters. In that case, you will need to remap each feature to your settings.
- Click the Next button in the "Point Geometry Text" screen.
- Click the Finish button in the "Confirm Feature Registration" screen. The focus returns to GSA after about a minute.
- Click on the Save command in GSA.
- Click on the Export command in GSA. This command creates the workspace with the features registered.